From f2ddb85cd22d3e5233d049d92ae8cb361a538114 Mon Sep 17 00:00:00 2001 From: Stevan Earl Date: Tue, 4 Aug 2026 12:54:56 -0700 Subject: [PATCH] fix: normalize blank biography birth groups (Problem #103) --- conversion/clean.sql | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/conversion/clean.sql b/conversion/clean.sql index b5b8cf4..8ed6acc 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -161,6 +161,11 @@ UPDATE biography UPDATE biography_update_log SET made_by = 'EVL' WHERE made_by = 'SF/EVL'; +-- Problem #103 BIOGRAPHY.B_BirthGroup values stored as empty strings ('') +-- rather than SQL NULL +UPDATE biography + SET b_birthgroup = NULLIF(BTRIM(b_birthgroup), '') + WHERE b_birthgroup IS DISTINCT FROM NULLIF(BTRIM(b_birthgroup), ''); -- -- 2.34.1